Basics

Introduction to SQL

• What is SQL?
• Setting up a SQL environment
• Basic SQL syntax
• Running SQL queries

Data Types

• Numeric data types
• String data types
• Date and time data types

Basic Queries

• SELECT statement
• WHERE clause
• ORDER BY clause
• LIMIT clause

Joins

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL JOIN

Intermediate

Advanced Queries

• GROUP BY clause
• HAVING clause
• Subqueries
• Common Table Expressions (CTEs)

Data Modification

• INSERT statement
• UPDATE statement
• DELETE statement
• MERGE statement

Indexes

• Creating indexes
• Using indexes for optimization
• Composite indexes
• Index maintenance

Transactions

• Starting a transaction
• Committing a transaction
• Rolling back a transaction
• Transaction isolation levels

Advanced

Stored Procedures and Functions

• Creating stored procedures
• Creating functions
• Parameters and return values
• Error handling in stored procedures

Triggers

• Creating triggers
• AFTER triggers
• BEFORE triggers
• INSTEAD OF triggers

Performance Tuning

• Query optimization
• Index tuning
• Execution plans
• Monitoring and profiling

Security

• Managing users and roles
• Granting and revoking permissions
• SQL injection prevention
• Data encryption